--------------------------------------------------------
--  File created - Tuesday-March-17-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Sequence ACTIVITY_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."ACTIVITY_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence ADDRESS_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."ADDRESS_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence AIMAG_DUUREG_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."AIMAG_DUUREG_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CITIZEN_ADDRESS_MAP_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CITIZEN_ADDRESS_MAP_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CITIZEN_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CITIZEN_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 141 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CONTACT_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CONTACT_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CONTRACT_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CONTRACT_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CREDIT_CONTRACT_MAP_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CREDIT_CONTRACT_MAP_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CREDIT_DEDICATION_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CREDIT_DEDICATION_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 110 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CREDIT_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CREDIT_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 181 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CREDIT_PAYMENT_TYPE_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CREDIT_PAYMENT_TYPE_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CREDIT_QUALITY_MAP_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CREDIT_QUALITY_MAP_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 141 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CREDIT_SCHEDULE_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CREDIT_SCHEDULE_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 81 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CREDIT_TYPE_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CREDIT_TYPE_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CURRENCY_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CURRENCY_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence CUSTOMER_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."CUSTOMER_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 22 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence DEBIT_TYPE_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."DEBIT_TYPE_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence DEBTOR_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."DEBTOR_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 141 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence JOB_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."JOB_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence LEGAL_ENTITY_ACTIVITY_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."LEGAL_ENTITY_ACTIVITY_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence LEGAL_ENTITY_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."LEGAL_ENTITY_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence LEGAL_ENTITY_OWNER_MAP_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."LEGAL_ENTITY_OWNER_MAP_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence LEGAL_ENTITY_TYPE_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."LEGAL_ENTITY_TYPE_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence QUALITY_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."QUALITY_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence SCHEDULE_TYPE_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."SCHEDULE_TYPE_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence SUM_KHOROO_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."SUM_KHOROO_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence USERS_DETAIL_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."USERS_DETAIL_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Sequence USERS_ID_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "LIMS"."USERS_ID_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE  NOPARTITION ;
--------------------------------------------------------
--  DDL for Table ACTIVITY
--------------------------------------------------------

  CREATE TABLE "LIMS"."ACTIVITY" 
   (	"ID" NUMBER(20,0), 
	"CODE" VARCHAR2(20 CHAR), 
	"NAME" VARCHAR2(512 CHAR), 
	"PARENT_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Table ADDRESS
--------------------------------------------------------

  CREATE TABLE "LIMS"."ADDRESS" 
   (	"ID" NUMBER(20,0), 
	"ADDRESS_AIMAG_NIISLEL" NUMBER(20,0), 
	"ADDRESS_SUM_DUUREG" NUMBER(20,0), 
	"FULL_ADDRESS" VARCHAR2(1024 CHAR), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0), 
	"UPDATED_DATE" DATE, 
	"UPDATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."ADDRESS"."ADDRESS_AIMAG_NIISLEL" IS 'Аймаг нийслэлийн ID';
   COMMENT ON COLUMN "LIMS"."ADDRESS"."ADDRESS_SUM_DUUREG" IS 'Сум дүүргийн ID';
   COMMENT ON COLUMN "LIMS"."ADDRESS"."FULL_ADDRESS" IS 'Хаяг бүтэн текстээр';
   COMMENT ON COLUMN "LIMS"."ADDRESS"."IS_ACTIVE" IS 'Идэвхитэй эсэх';
   COMMENT ON COLUMN "LIMS"."ADDRESS"."CREATED_DATE" IS 'Үүсгэсэн огноо';
   COMMENT ON COLUMN "LIMS"."ADDRESS"."CREATED_USER_ID" IS 'Үүсгэсэн хэрэглэгч';
   COMMENT ON COLUMN "LIMS"."ADDRESS"."UPDATED_DATE" IS 'Хамгийн сүүлд өөрчлөлт орсон огноо';
   COMMENT ON COLUMN "LIMS"."ADDRESS"."UPDATED_USER_ID" IS 'Хамгийн сүүлд өөрчлөлт орсон хэрэглэгч';
--------------------------------------------------------
--  DDL for Table AIMAG_DUUREG
--------------------------------------------------------

  CREATE TABLE "LIMS"."AIMAG_DUUREG" 
   (	"ID" NUMBER(20,0), 
	"CODE" VARCHAR2(20 CHAR), 
	"NAME" VARCHAR2(56 CHAR), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Table CITIZEN
--------------------------------------------------------

  CREATE TABLE "LIMS"."CITIZEN" 
   (	"ID" NUMBER, 
	"FAMILY_NAME" VARCHAR2(128 CHAR), 
	"LAST_NAME" VARCHAR2(128 CHAR), 
	"FIRST_NAME" VARCHAR2(128 CHAR), 
	"REGISTER_NUMBER" VARCHAR2(20 CHAR), 
	"IS_MARRIED" NUMBER(1,0), 
	"IS_ACTIVE" NUMBER(1,0), 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."CITIZEN"."FAMILY_NAME" IS 'Ургын овог';
   COMMENT ON COLUMN "LIMS"."CITIZEN"."LAST_NAME" IS 'Эцэг /эх/ - ийн нэр';
   COMMENT ON COLUMN "LIMS"."CITIZEN"."FIRST_NAME" IS 'Өөрийн нэр';
   COMMENT ON COLUMN "LIMS"."CITIZEN"."REGISTER_NUMBER" IS 'Регистрийн дугаар';
   COMMENT ON COLUMN "LIMS"."CITIZEN"."IS_MARRIED" IS 'Гэрлэсэн эсэх';
   COMMENT ON COLUMN "LIMS"."CITIZEN"."IS_ACTIVE" IS 'Идэвхитэй эсэх';
   COMMENT ON COLUMN "LIMS"."CITIZEN"."CREATED_DATE" IS 'Үүсгэсэн огноо';
   COMMENT ON COLUMN "LIMS"."CITIZEN"."CREATED_USER_ID" IS 'Үүсгэсэн хэрэглэгч';
   COMMENT ON TABLE "LIMS"."CITIZEN"  IS 'Иргэн';
--------------------------------------------------------
--  DDL for Table CITIZEN_ADDRESS_MAP
--------------------------------------------------------

  CREATE TABLE "LIMS"."CITIZEN_ADDRESS_MAP" 
   (	"ID" NUMBER(20,0), 
	"CITIZEN_ID" NUMBER(20,0), 
	"ADDRESS_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0), 
	"UPDATED_DATE" DATE, 
	"UPDATED_USER_ID" NUMBER
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Table CONTRACT
--------------------------------------------------------

  CREATE TABLE "LIMS"."CONTRACT" 
   (	"ID" NUMBER(20,0), 
	"CONTRACT_TYPE_ID" NUMBER(20,0), 
	"SOURCE_REGISTER_NUMBER" VARCHAR2(20 CHAR), 
	"TARGET_REGISTER_NUMBER" VARCHAR2(20 CHAR), 
	"CODE" VARCHAR2(20 CHAR), 
	"NAME" VARCHAR2(256 CHAR), 
	"CONTRACT_SIGNED_DATE" DATE, 
	"CONTRACT_BEGIN_DATE" DATE, 
	"CONTRACT_END_DATE" DATE, 
	"DESCRIPTION" VARCHAR2(1024 CHAR), 
	"IS_ACTIVE" NUMBER(1,0), 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."CONTRACT"."ID" IS 'PK';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."CONTRACT_TYPE_ID" IS 'Гэрээний төрөл';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."SOURCE_REGISTER_NUMBER" IS 'Гэрээ байгуулсан хариуцагч этгээдийн регистрийн дугаар (Зээл олгогч)';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."TARGET_REGISTER_NUMBER" IS 'Харилцагч этгээдийн регистрийн дугаар (Зээлдэгч)';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."CODE" IS 'Код';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."NAME" IS 'Нэр';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."CONTRACT_SIGNED_DATE" IS 'Гэрээнд гарын үсэг зурсан огноо';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."CONTRACT_BEGIN_DATE" IS 'Гэрээ мөрдөж эхлэх огноо';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."CONTRACT_END_DATE" IS 'Гэрээ мөрдөж дуусах огноо';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."DESCRIPTION" IS 'Нэмэлт тайлбар';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."IS_ACTIVE" IS 'Төлөв';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."CREATED_DATE" IS 'Үүсгэсэн огноо';
   COMMENT ON COLUMN "LIMS"."CONTRACT"."CREATED_USER_ID" IS 'Үүсгэсэн хэрэглэгч';
   COMMENT ON TABLE "LIMS"."CONTRACT"  IS 'Харилцагчын байгуулсан гэрээ';
--------------------------------------------------------
--  DDL for Table CREDIT
--------------------------------------------------------

  CREATE TABLE "LIMS"."CREDIT" 
   (	"ID" NUMBER(20,0), 
	"BEGIN_DATE" DATE, 
	"END_DATE" DATE, 
	"INITIAL_AMOUNT" NUMBER(20,2), 
	"INTEREST_PERCENT" NUMBER(5,2), 
	"INTEREST_AMOUNT" NUMBER(20,2), 
	"TOTAL_AMOUNT" NUMBER(20,0), 
	"BALANCE" NUMBER(20,2), 
	"INTEREST_BALANCE" NUMBER(20,2), 
	"TOTAL_BALANCE" NUMBER(20,2), 
	"CURRENCY_ID" NUMBER(20,0), 
	"TYPE_ID" NUMBER(20,0), 
	"DEDICATION_ID" NUMBER(20,0), 
	"PAYMENT_TYPE_ID" NUMBER(20,0), 
	"INTEREST_PAYMENT_TYPE_ID" NUMBER(20,0), 
	"DESCRIPTION" VARCHAR2(1024 CHAR), 
	"STATUS_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CUSTOMER_ID" NUMBER(20,0), 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0), 
	"DEBTOR_ID" NUMBER(20,0), 
	"SCHEDULE_LENGTH" NUMBER(4,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."CREDIT"."BEGIN_DATE" IS 'Эхлэх огноо';
   COMMENT ON COLUMN "LIMS"."CREDIT"."END_DATE" IS 'Дуусах огноо';
   COMMENT ON COLUMN "LIMS"."CREDIT"."INITIAL_AMOUNT" IS 'Олгосон дүн';
   COMMENT ON COLUMN "LIMS"."CREDIT"."INTEREST_PERCENT" IS 'Хүүгийн хувь';
   COMMENT ON COLUMN "LIMS"."CREDIT"."INTEREST_AMOUNT" IS 'Хүүгийн хэмжээ';
   COMMENT ON COLUMN "LIMS"."CREDIT"."TOTAL_AMOUNT" IS 'Нийт зээлийн дүн (Үндсэн дүн + Хүү)';
   COMMENT ON COLUMN "LIMS"."CREDIT"."BALANCE" IS 'Зээлийн үлдэгдэл (Зөвхөн үндсэн зээл)';
   COMMENT ON COLUMN "LIMS"."CREDIT"."INTEREST_BALANCE" IS 'Хүүгийн үлдэгдэл (Зөвхөн хүүгийн)';
   COMMENT ON COLUMN "LIMS"."CREDIT"."TOTAL_BALANCE" IS 'Нийт зээлийн үлдэгдэл (Үндсэн зээл + Хүү)';
   COMMENT ON COLUMN "LIMS"."CREDIT"."CURRENCY_ID" IS 'Валют';
   COMMENT ON COLUMN "LIMS"."CREDIT"."TYPE_ID" IS 'Зээлийн төрөл ';
   COMMENT ON COLUMN "LIMS"."CREDIT"."DEDICATION_ID" IS 'Зээлийг зориулалт';
   COMMENT ON COLUMN "LIMS"."CREDIT"."PAYMENT_TYPE_ID" IS 'Үндсэн зээлийн төлөлтийн хэлбэр';
   COMMENT ON COLUMN "LIMS"."CREDIT"."INTEREST_PAYMENT_TYPE_ID" IS 'Хүүгийн төлөлтийн хэлбэр';
   COMMENT ON COLUMN "LIMS"."CREDIT"."DESCRIPTION" IS 'Нэмэлт тайлбар';
   COMMENT ON COLUMN "LIMS"."CREDIT"."STATUS_ID" IS 'Ажлын урсгалын төлөв';
   COMMENT ON COLUMN "LIMS"."CREDIT"."CUSTOMER_ID" IS 'Харилцагч';
   COMMENT ON COLUMN "LIMS"."CREDIT"."CREATED_DATE" IS 'Үүсгэсэн огноо';
   COMMENT ON COLUMN "LIMS"."CREDIT"."CREATED_USER_ID" IS 'Үүсгэсэн хэрэглэгч';
   COMMENT ON COLUMN "LIMS"."CREDIT"."SCHEDULE_LENGTH" IS 'Зээлийн график хугацааны тоо (Default : Сараар)';
   COMMENT ON TABLE "LIMS"."CREDIT"  IS 'Зээл';
--------------------------------------------------------
--  DDL for Table CREDIT_CONTRACT_MAP
--------------------------------------------------------

  CREATE TABLE "LIMS"."CREDIT_CONTRACT_MAP" 
   (	"ID" NUMBER(20,0), 
	"CREDIT_ID" NUMBER(20,0), 
	"CONTRACT_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."CREDIT_CONTRACT_MAP"."ID" IS 'PK';
   COMMENT ON COLUMN "LIMS"."CREDIT_CONTRACT_MAP"."CREDIT_ID" IS 'Зээлийн ID';
   COMMENT ON COLUMN "LIMS"."CREDIT_CONTRACT_MAP"."CONTRACT_ID" IS 'Гэрээ ID';
   COMMENT ON COLUMN "LIMS"."CREDIT_CONTRACT_MAP"."IS_ACTIVE" IS 'Төлөв';
   COMMENT ON COLUMN "LIMS"."CREDIT_CONTRACT_MAP"."CREATED_DATE" IS 'Үүсгэсэн огноо';
   COMMENT ON COLUMN "LIMS"."CREDIT_CONTRACT_MAP"."CREATED_USER_ID" IS 'Үүсгэсэн хэрэглэгч';
   COMMENT ON TABLE "LIMS"."CREDIT_CONTRACT_MAP"  IS 'Зээлийн гэрээ';
--------------------------------------------------------
--  DDL for Table CREDIT_DEDICATION
--------------------------------------------------------

  CREATE TABLE "LIMS"."CREDIT_DEDICATION" 
   (	"ID" NUMBER(20,0), 
	"CODE" VARCHAR2(20 CHAR), 
	"NAME" VARCHAR2(515 CHAR), 
	"DESCRIPTION" VARCHAR2(1024 CHAR), 
	"PARENT_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."CREDIT_DEDICATION"."ID" IS 'PK';
   COMMENT ON COLUMN "LIMS"."CREDIT_DEDICATION"."NAME" IS 'Нэр';
   COMMENT ON COLUMN "LIMS"."CREDIT_DEDICATION"."DESCRIPTION" IS 'Тайлбар';
   COMMENT ON COLUMN "LIMS"."CREDIT_DEDICATION"."PARENT_ID" IS 'Эцэг ID';
   COMMENT ON TABLE "LIMS"."CREDIT_DEDICATION"  IS 'Зээлийн зориулалт';
--------------------------------------------------------
--  DDL for Table CREDIT_PAYMENT_TYPE
--------------------------------------------------------

  CREATE TABLE "LIMS"."CREDIT_PAYMENT_TYPE" 
   (	"ID" NUMBER(20,0), 
	"CODE" VARCHAR2(20 CHAR), 
	"NAME" VARCHAR2(256 CHAR), 
	"DESCRIPTION" VARCHAR2(1024 CHAR), 
	"PARENT_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0), 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Table CREDIT_QUALITY_MAP
--------------------------------------------------------

  CREATE TABLE "LIMS"."CREDIT_QUALITY_MAP" 
   (	"ID" NUMBER(20,0), 
	"CREDIT_ID" NUMBER(20,0), 
	"QUALITY_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0), 
	"UPDATED_DATE" DATE, 
	"UPDATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."CREDIT_QUALITY_MAP"."CREDIT_ID" IS 'Зээлийн ID';
   COMMENT ON COLUMN "LIMS"."CREDIT_QUALITY_MAP"."QUALITY_ID" IS 'Чанар';
   COMMENT ON COLUMN "LIMS"."CREDIT_QUALITY_MAP"."IS_ACTIVE" IS 'Төлөв';
   COMMENT ON COLUMN "LIMS"."CREDIT_QUALITY_MAP"."CREATED_DATE" IS 'Үүсгэсэн огноо';
   COMMENT ON COLUMN "LIMS"."CREDIT_QUALITY_MAP"."CREATED_USER_ID" IS 'Үүсгэсэн хэрэглэгч';
   COMMENT ON COLUMN "LIMS"."CREDIT_QUALITY_MAP"."UPDATED_DATE" IS 'Өөрчлөлт орсон огноо';
   COMMENT ON COLUMN "LIMS"."CREDIT_QUALITY_MAP"."UPDATED_USER_ID" IS 'Өөрчлөлт оруулсан хэрэглэгч';
   COMMENT ON TABLE "LIMS"."CREDIT_QUALITY_MAP"  IS 'Зээлийн чанар';
--------------------------------------------------------
--  DDL for Table CREDIT_SCHEDULE
--------------------------------------------------------

  CREATE TABLE "LIMS"."CREDIT_SCHEDULE" 
   (	"ID" NUMBER(20,0), 
	"CREDIT_ID" NUMBER(20,0), 
	"SCHEDULE_TYPE_ID" NUMBER(20,0), 
	"ONE_AMOUNT" NUMBER(20,4), 
	"TARGET_DATE" DATE, 
	"DAYS" NUMBER(20,0), 
	"MAIN_AMOUNT" NUMBER(20,4), 
	"INTEREST_AMOUNT" NUMBER(20,4), 
	"TOTAL_AMOUNT" NUMBER(20,4), 
	"BALANCE" NUMBER(20,4), 
	"DEADLINE" DATE, 
	"STATUS_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0), 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."CREDIT_ID" IS 'Зээлийн ID';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."SCHEDULE_TYPE_ID" IS 'Хувиарын төлөлтийн төрөл';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."ONE_AMOUNT" IS 'Нэгж хугацаанд төлөх зээлийн хэмжээ';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."TARGET_DATE" IS 'Төлбөх огноо';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."DAYS" IS 'Хамрах хоног';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."MAIN_AMOUNT" IS 'Үндсэн зээлийн хэмжээ';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."INTEREST_AMOUNT" IS 'Хүүгийн хэмжээ';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."TOTAL_AMOUNT" IS 'Нийт зээлийн хэмжээ';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."BALANCE" IS 'Үлдэгдэл';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."DEADLINE" IS 'Төлөх эцсийн хугацаа';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."STATUS_ID" IS 'Төлөв';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."IS_ACTIVE" IS 'Идэвхитэй эсэх';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."CREATED_DATE" IS 'Үүсгэсэн огноо';
   COMMENT ON COLUMN "LIMS"."CREDIT_SCHEDULE"."CREATED_USER_ID" IS 'Үүсгэсэн хэрэглэгч';
--------------------------------------------------------
--  DDL for Table CREDIT_TYPE
--------------------------------------------------------

  CREATE TABLE "LIMS"."CREDIT_TYPE" 
   (	"ID" NUMBER(20,0), 
	"NAME" VARCHAR2(256 CHAR), 
	"DESCRIPTION" VARCHAR2(1024 CHAR), 
	"PARENT_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0), 
	"CODE" VARCHAR2(20 CHAR)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON TABLE "LIMS"."CREDIT_TYPE"  IS 'Зээлийн төрөл';
--------------------------------------------------------
--  DDL for Table CURRENCY
--------------------------------------------------------

  CREATE TABLE "LIMS"."CURRENCY" 
   (	"ID" NUMBER, 
	"NAME" VARCHAR2(256 CHAR), 
	"ABBREVIATION" VARCHAR2(20 CHAR), 
	"SYMBOL" VARCHAR2(20 CHAR), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Table CUSTOMER
--------------------------------------------------------

  CREATE TABLE "LIMS"."CUSTOMER" 
   (	"ID" NUMBER(20,0), 
	"NAME" VARCHAR2(512 CHAR)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON TABLE "LIMS"."CUSTOMER"  IS 'Харилцагч';
--------------------------------------------------------
--  DDL for Table DEBIT_TYPE
--------------------------------------------------------

  CREATE TABLE "LIMS"."DEBIT_TYPE" 
   (	"ID" NUMBER(20,0), 
	"CODE" VARCHAR2(20 BYTE), 
	"NAME" VARCHAR2(256 BYTE), 
	"DESCRIPTION" VARCHAR2(1024 BYTE), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."DEBIT_TYPE"."ID" IS 'PK';
   COMMENT ON TABLE "LIMS"."DEBIT_TYPE"  IS 'Барьцааны төрөл';
--------------------------------------------------------
--  DDL for Table DEBTOR
--------------------------------------------------------

  CREATE TABLE "LIMS"."DEBTOR" 
   (	"ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0), 
	"CITIZEN_ID" NUMBER(20,0), 
	"LEGAL_ENTITY_ID" NUMBER(20,0), 
	"REGISTER_NUMBER" VARCHAR2(20 CHAR), 
	"NAME" VARCHAR2(128 CHAR), 
	"LAST_NAME" VARCHAR2(128 CHAR)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."DEBTOR"."ID" IS 'PK';
   COMMENT ON COLUMN "LIMS"."DEBTOR"."IS_ACTIVE" IS 'Идэвхитэй';
   COMMENT ON COLUMN "LIMS"."DEBTOR"."CREATED_DATE" IS 'Үүсгэсэн огноо';
   COMMENT ON COLUMN "LIMS"."DEBTOR"."CREATED_USER_ID" IS 'Үүсгэсэн хэрэглэгч';
   COMMENT ON COLUMN "LIMS"."DEBTOR"."CITIZEN_ID" IS 'Иргэн';
   COMMENT ON COLUMN "LIMS"."DEBTOR"."LEGAL_ENTITY_ID" IS 'Аж ахуйн нэгж';
   COMMENT ON COLUMN "LIMS"."DEBTOR"."REGISTER_NUMBER" IS 'Регистрийн дугаар';
   COMMENT ON COLUMN "LIMS"."DEBTOR"."NAME" IS 'Нэр';
   COMMENT ON COLUMN "LIMS"."DEBTOR"."LAST_NAME" IS 'Овог';
   COMMENT ON TABLE "LIMS"."DEBTOR"  IS 'Зээлдэгч иргэн';
--------------------------------------------------------
--  DDL for Table JOB
--------------------------------------------------------

  CREATE TABLE "LIMS"."JOB" 
   (	"ID" NUMBER, 
	"POSITION_ID" NUMBER(20,0), 
	"POSITION_NAME" VARCHAR2(512 CHAR), 
	"NAME" VARCHAR2(512 CHAR), 
	"IS_ACTIVE" NUMBER(1,0), 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0), 
	"ADDRESS" VARCHAR2(1024 CHAR), 
	"PHONE" VARCHAR2(50 CHAR), 
	"EMAIL" VARCHAR2(128 CHAR), 
	"IS_CURRENT" NUMBER(1,0) DEFAULT 1, 
	"CITIZEN_ID" NUMBER(20,0)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "LIMS" ;

   COMMENT ON TABLE "LIMS"."JOB"  IS 'Ажлын газар';
--------------------------------------------------------
--  DDL for Table LEGAL_ENTITY
--------------------------------------------------------

  CREATE TABLE "LIMS"."LEGAL_ENTITY" 
   (	"ID" NUMBER(20,0), 
	"NAME" VARCHAR2(256 CHAR), 
	"NAME_EN" VARCHAR2(256 CHAR), 
	"REGISTER_NUMBER" VARCHAR2(20 CHAR), 
	"TAX_NUMBER" VARCHAR2(20 CHAR), 
	"TYPE_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON TABLE "LIMS"."LEGAL_ENTITY"  IS 'Хуулийн этгээд';
--------------------------------------------------------
--  DDL for Table LEGAL_ENTITY_ACTIVITY
--------------------------------------------------------

  CREATE TABLE "LIMS"."LEGAL_ENTITY_ACTIVITY" 
   (	"ID" NUMBER(20,0), 
	"LEGAL_ENTITY_ID" NUMBER(20,0), 
	"ACTIVITY_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "LIMS" ;

   COMMENT ON TABLE "LIMS"."LEGAL_ENTITY_ACTIVITY"  IS 'Хуулийн этгээдийн үйл ажиллагаа';
--------------------------------------------------------
--  DDL for Table LEGAL_ENTITY_OWNER_MAP
--------------------------------------------------------

  CREATE TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" 
   (	"ID" NUMBER(20,0), 
	"LEGAL_ENTITY_ID" NUMBER(20,0), 
	"CITIZEN_ID" NUMBER(20,0), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP"  IS 'Хуулийн этгээдийн эзэмшигч';
--------------------------------------------------------
--  DDL for Table LEGAL_ENTITY_TYPE
--------------------------------------------------------

  CREATE TABLE "LIMS"."LEGAL_ENTITY_TYPE" 
   (	"ID" NUMBER(20,0), 
	"NAME" VARCHAR2(256 CHAR), 
	"CODE" VARCHAR2(20 CHAR), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON TABLE "LIMS"."LEGAL_ENTITY_TYPE"  IS 'Хуулийн этгээдийн хэлбэр';
--------------------------------------------------------
--  DDL for Table QUALITY
--------------------------------------------------------

  CREATE TABLE "LIMS"."QUALITY" 
   (	"ID" NUMBER(20,0), 
	"NAME" VARCHAR2(256 CHAR)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Table SCHEDULE_TYPE
--------------------------------------------------------

  CREATE TABLE "LIMS"."SCHEDULE_TYPE" 
   (	"ID" NUMBER(20,0), 
	"CODE" VARCHAR2(20 CHAR), 
	"NAME" VARCHAR2(128 CHAR), 
	"DESCRIPTION" VARCHAR2(512 CHAR), 
	"IS_ACTIVE" NUMBER(1,0), 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "LIMS" ;

   COMMENT ON COLUMN "LIMS"."SCHEDULE_TYPE"."CODE" IS 'Код';
   COMMENT ON COLUMN "LIMS"."SCHEDULE_TYPE"."NAME" IS 'Нэр';
   COMMENT ON COLUMN "LIMS"."SCHEDULE_TYPE"."DESCRIPTION" IS 'Тайлбар';
   COMMENT ON COLUMN "LIMS"."SCHEDULE_TYPE"."IS_ACTIVE" IS 'Идэюхитэй эсэх';
   COMMENT ON COLUMN "LIMS"."SCHEDULE_TYPE"."CREATED_DATE" IS 'Үүсгэсэн огноо';
   COMMENT ON COLUMN "LIMS"."SCHEDULE_TYPE"."CREATED_USER_ID" IS 'Үүсгэсэн хэрэгэлэгч';
--------------------------------------------------------
--  DDL for Table SUM_KHOROO
--------------------------------------------------------

  CREATE TABLE "LIMS"."SUM_KHOROO" 
   (	"ID" NUMBER(20,0), 
	"AIMAG_NIISLEL_ID" NUMBER(20,0), 
	"CODE" VARCHAR2(20 CHAR), 
	"NAME" VARCHAR2(256 CHAR), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Table USERS
--------------------------------------------------------

  CREATE TABLE "LIMS"."USERS" 
   (	"ID" NUMBER, 
	"CUSTOMER_ID" NUMBER(20,0), 
	"USERNAME" VARCHAR2(50 CHAR), 
	"EMAIL" VARCHAR2(128 CHAR), 
	"PASSWORD" VARCHAR2(50 CHAR), 
	"PASSWORD_TOKEN" VARCHAR2(128 CHAR), 
	"IS_ACTIVE" NUMBER(1,0) DEFAULT 1, 
	"CREATED_DATE" DATE, 
	"CREATED_USER_ID" NUMBER(20,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;

   COMMENT ON TABLE "LIMS"."USERS"  IS 'Системийн хэрэглэгчид';
--------------------------------------------------------
--  DDL for Table USERS_DETAIL
--------------------------------------------------------

  CREATE TABLE "LIMS"."USERS_DETAIL" 
   (	"ID" NUMBER(20,0), 
	"USER_ID" NUMBER(20,0), 
	"CUSTOMER_ID" NUMBER(20,0), 
	"FIRST_NAME" VARCHAR2(50 CHAR), 
	"LAST_NAME" VARCHAR2(50 CHAR), 
	"FAMILY_NAME" VARCHAR2(20 CHAR), 
	"POSITION_ID" NUMBER(20,0), 
	"POSITION_NAME" VARCHAR2(256 CHAR), 
	"IMAGE_URL" VARCHAR2(512 CHAR)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "LIMS" ;

   COMMENT ON TABLE "LIMS"."USERS_DETAIL"  IS 'Хэрэглэгчийн дэлгэрэнгүй мэдээлэл';
REM INSERTING into LIMS.ACTIVITY
SET DEFINE OFF;
REM INSERTING into LIMS.ADDRESS
SET DEFINE OFF;
REM INSERTING into LIMS.AIMAG_DUUREG
SET DEFINE OFF;
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (1,null,'Архангай ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (2,null,'Баян-Өлгий ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (3,null,'Баянхонгор ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (4,null,'Булган ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (5,null,'Говь-Алтай ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (6,null,'Говьсүмбэр',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (7,null,'Дархан-Уул',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (8,null,'Дорноговь ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (9,null,'Дорнод ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (10,null,'Дундговь',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (11,null,'Завхан ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (12,null,'Орхон ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (13,null,'Өвөрхангай ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (14,null,'Өмнөговь ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (15,null,'Сүхбаатар ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (16,null,'Сэлэнгэ ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (17,null,'Төв ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (18,null,'Увс',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (19,null,'Ховд ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (20,null,'Хөвсгөл ',1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.AIMAG_DUUREG (ID,CODE,NAME,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (21,null,'Хэнтий ',1,to_date('10-FEB-15','DD-MON-RR'),1);
REM INSERTING into LIMS.CITIZEN
SET DEFINE OFF;
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (11,'uyuikyui','yuiyu','iyuuio','uiouioui',1,1,to_date('05-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (21,'sdfdsf','dfsdf','sdfsdf','dsfsd23423',1,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (121,null,'asda','dfdfd','er8899442223',null,1,to_date('05-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (24,'AARRR','AARRR','AARRR','AARRR',0,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (26,'eeeee33','eeeee44','eeeee44','eeeee33',0,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (27,'eeeee335566','eeeee44','eeeee44666','eeeee335566',0,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (28,'deee335566','eeeee44','eeeee44666','deee335566',0,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (101,'33DFGDFG','ASDA','SFSDF','33DFGDFG',1,1,to_date('17-FEB-15','DD-MON-RR'),2);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (102,'ӨЮ86010777','Бүрэнжаргал','Мөнх-эрдэнэ','ӨЮ86010777',0,1,to_date('17-FEB-15','DD-MON-RR'),2);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (104,'ӨЮ86010756','Бүрэнжаргал','Мөнх-эрдэнэ','ӨЮ86010756',0,1,to_date('17-FEB-15','DD-MON-RR'),2);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (25,'eeeee','eeeee','eeeee','eeeee',0,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (29,'566eee335566','eeeee44','eeeee44666','566eee335566',0,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (30,'ttee335566','eeeee44','eeeee44666',null,0,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (31,'ggr44rrrr2','ggrrrrr','ggrrrrr','ggr44rrrr2',0,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (32,'ggr44rr55r2','ggrrrrr','ggrrrrr','ggr44rr55r',0,1,to_date('06-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (81,'МЮ86010777','Бүрэнцжаргал','Мөнх-эрдэнэ','МЮ86010777',1,1,to_date('12-FEB-15','DD-MON-RR'),2);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (5,'dfgdfg','dfgdf','sdf','dfgdfgdfg',1,1,to_date('05-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (103,'ӨЮ86010766','Бүрэнжаргал','Мөнх-эрдэнэ','ӨЮ86010766',0,1,to_date('17-FEB-15','DD-MON-RR'),2);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (10,'gfhgfh',null,'hth','ththth',1,1,to_date('05-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (12,'sdasdasd','asda','asdasd','fg42342342',0,1,to_date('05-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (41,'HFGHFGH','HFGH','HFG','HFGHFGH',0,1,to_date('10-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CITIZEN (ID,FAMILY_NAME,LAST_NAME,FIRST_NAME,REGISTER_NUMBER,IS_MARRIED,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (61,'ASDSAD','ASDASD','ASDA','SDASDSAD',null,1,to_date('11-FEB-15','DD-MON-RR'),2);
REM INSERTING into LIMS.CITIZEN_ADDRESS_MAP
SET DEFINE OFF;
REM INSERTING into LIMS.CONTRACT
SET DEFINE OFF;
Insert into LIMS.CONTRACT (ID,CONTRACT_TYPE_ID,SOURCE_REGISTER_NUMBER,TARGET_REGISTER_NUMBER,CODE,NAME,CONTRACT_SIGNED_DATE,CONTRACT_BEGIN_DATE,CONTRACT_END_DATE,DESCRIPTION,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (1,1,'1','2','2','asd',to_date('16-MAR-15','DD-MON-RR'),to_date('17-APR-16','DD-MON-RR'),to_date('18-MAY-17','DD-MON-RR'),'a',1,to_date('16-MAR-15','DD-MON-RR'),1);
REM INSERTING into LIMS.CREDIT
SET DEFINE OFF;
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (8,to_date('11-FEB-15','DD-MON-RR'),to_date('24-FEB-15','DD-MON-RR'),2243,4,134,943,100,101,102,1,1,4,5,3,'343',1,1,1,to_date('10-FEB-15','DD-MON-RR'),2,5,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (21,to_date('12-FEB-15','DD-MON-RR'),to_date('24-FEB-15','DD-MON-RR'),34,3,4,5,34,4,5,1,1,2,2,2,'dfgfdg',1,1,1,to_date('10-FEB-15','DD-MON-RR'),2,6,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (103,to_date('10-MAR-15','DD-MON-RR'),to_date('24-MAR-15','DD-MON-RR'),21312,12,12312,31231,21312,12312,31231,1,3,2,3,3,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (104,to_date('12-MAR-15','DD-MON-RR'),to_date('22-MAR-15','DD-MON-RR'),12312,12,1231,1231231,12312,1231,1231231,1,2,5,3,3,'234234',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (105,to_date('12-MAR-15','DD-MON-RR'),to_date('22-MAR-15','DD-MON-RR'),12312,12,1231,1231231,12312,1231,1231231,1,2,5,3,3,'234234',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (101,to_date('10-MAR-15','DD-MON-RR'),to_date('24-MAR-15','DD-MON-RR'),21312,12,12312,31231,21312,12312,31231,1,3,2,3,3,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (102,to_date('10-MAR-15','DD-MON-RR'),to_date('24-MAR-15','DD-MON-RR'),21312,12,12312,31231,21312,12312,31231,1,3,2,3,3,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (107,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (108,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (109,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (110,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (111,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (112,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (113,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (114,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (115,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (116,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (117,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (119,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (120,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (121,to_date('01-MAR-15','DD-MON-RR'),to_date('23-MAR-15','DD-MON-RR'),123,1,12,135,123,12,135,1,1,null,2,2,null,1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,21,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (122,to_date('01-MAR-15','DD-MON-RR'),to_date('23-MAR-15','DD-MON-RR'),123,1,12,135,123,12,135,1,1,null,2,2,null,1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,21,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (128,to_date('01-MAR-15','DD-MON-RR'),to_date('17-MAR-15','DD-MON-RR'),123,1,2,125,123,2,125,1,2,2,2,2,'232',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,21,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (130,to_date('01-MAR-15','DD-MON-RR'),to_date('02-MAR-15','DD-MON-RR'),3123,12,1212,4335,3123,1212,4335,1,1,1,1,1,'asd',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,21,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (131,to_date('01-MAR-15','DD-MON-RR'),to_date('02-MAR-15','DD-MON-RR'),3123,12,1212,4335,3123,1212,4335,1,1,1,1,1,'asd',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,21,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (132,to_date('01-MAR-15','DD-MON-RR'),to_date('02-MAR-15','DD-MON-RR'),3123,12,1212,4335,3123,1212,4335,1,1,1,1,1,'asd',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,21,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (133,to_date('01-MAR-15','DD-MON-RR'),to_date('02-MAR-15','DD-MON-RR'),3123,12,1212,4335,3123,1212,4335,1,1,1,1,1,'asd',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,21,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (134,to_date('01-MAR-15','DD-MON-RR'),to_date('31-MAR-15','DD-MON-RR'),1222,2,33,1255,1222,33,1255,1,1,3,1,1,'12321',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,21,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (145,to_date('13-MAR-15','DD-MON-RR'),to_date('08-MAR-15','DD-MON-RR'),23123,12,131,23254,23123,131,23254,1,3,2,4,4,'adasd',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,22,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (151,to_date('05-MAR-15','DD-MON-RR'),to_date('09-MAR-15','DD-MON-RR'),123123,12,22,123145,123123,22,123145,1,2,3,2,2,'asdasd',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,22,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (163,to_date('25-MAR-15','DD-MON-RR'),to_date('23-MAR-15','DD-MON-RR'),123,123,111,234,123,111,234,1,2,2,1,1,null,1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,22,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (106,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (129,to_date('01-MAR-15','DD-MON-RR'),to_date('02-MAR-15','DD-MON-RR'),3123,12,1212,4335,3123,1212,4335,1,1,1,1,1,'asd',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,21,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (9,to_date('11-FEB-15','DD-MON-RR'),to_date('24-FEB-15','DD-MON-RR'),3243,34,4334,3343,3243,4334,3343,1,1,4,5,3,'343',1,1,1,to_date('10-FEB-15','DD-MON-RR'),2,5,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (81,to_date('02-FEB-15','DD-MON-RR'),to_date('26-FEB-25','DD-MON-RR'),15000000,30,76575,20000000,15000000,76575,20000000,1,4,64,4,4,'FULL TEST',1,1,1,to_date('12-FEB-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (150,to_date('05-MAR-15','DD-MON-RR'),to_date('09-MAR-15','DD-MON-RR'),123123,12,22,123145,123123,22,123145,1,2,3,2,2,'asdasd',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,22,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (156,to_date('05-MAR-15','DD-MON-RR'),to_date('09-MAR-15','DD-MON-RR'),123123,12,22,123145,123123,22,123145,1,2,3,2,2,'asdasd',1,1,1,to_date('16-MAR-15','DD-MON-RR'),2,22,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (118,to_date('28-MAR-15','DD-MON-RR'),to_date('25-MAR-15','DD-MON-RR'),123,2,23123,1233,123,23123,1233,5,3,6,2,2,'123123',1,1,1,to_date('15-MAR-15','DD-MON-RR'),2,81,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (42,to_date('04-FEB-15','DD-MON-RR'),to_date('16-FEB-15','DD-MON-RR'),234234,34,234234,23423423,234234,234234,23423423,1,2,2,3,3,'dfg dfg sdfg sdg',1,1,1,to_date('10-FEB-15','DD-MON-RR'),2,7,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (43,to_date('11-FEB-15','DD-MON-RR'),to_date('25-FEB-15','DD-MON-RR'),1231,23,12131,1231,1231,12131,1231,1,2,6,3,4,'sdsf sdfsdf sdf ',1,1,1,to_date('10-FEB-15','DD-MON-RR'),2,6,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (44,to_date('18-FEB-15','DD-MON-RR'),to_date('28-FEB-15','DD-MON-RR'),234234,12,12312,3143242,234234,12312,3143242,1,1,3,3,4,'sdfsdfs',1,1,1,to_date('11-FEB-15','DD-MON-RR'),2,23,null);
Insert into LIMS.CREDIT (ID,BEGIN_DATE,END_DATE,INITIAL_AMOUNT,INTEREST_PERCENT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,INTEREST_BALANCE,TOTAL_BALANCE,CURRENCY_ID,TYPE_ID,DEDICATION_ID,PAYMENT_TYPE_ID,INTEREST_PAYMENT_TYPE_ID,DESCRIPTION,STATUS_ID,IS_ACTIVE,CUSTOMER_ID,CREATED_DATE,CREATED_USER_ID,DEBTOR_ID,SCHEDULE_LENGTH) values (62,to_date('11-FEB-15','DD-MON-RR'),to_date('27-FEB-15','DD-MON-RR'),234234,23,324435,345312,234234,324435,345312,2,1,7,5,3,'werwerwer',1,1,1,to_date('11-FEB-15','DD-MON-RR'),2,61,null);
REM INSERTING into LIMS.CREDIT_CONTRACT_MAP
SET DEFINE OFF;
Insert into LIMS.CREDIT_CONTRACT_MAP (ID,CREDIT_ID,CONTRACT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (1,163,1,1,to_date('16-MAR-15','DD-MON-RR'),2);
REM INSERTING into LIMS.CREDIT_DEDICATION
SET DEFINE OFF;
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (1,'A01','Газар тариалан, Мал аж ахуйн үйлдвэрлэл, Ан агнуур болон түүнд туслах үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (2,'A','Хөдөө аж ахуй,ойн аж ахуй, загас барилт, ан агнуур',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (3,'B','Уул уурхай, олборлолт',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (4,'C','Боловсруулах үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (5,'D','Цахилгаан, хий, уур, агааржуулалтын хангамж',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (6,'E','Усан хангамж; бохир ус, хог, хаягдлын менежмент болон цэвэрлэх үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (7,'F','Барилга',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (8,'G','Бөөний болон жижиглэн худалдаа; машин, мотоциклийн засвар үйлчилгээ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (9,'H','Тээвэр ба агуулахын үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (10,'I','Байр, сууц болон хоол хүнсээр үйлчлэх үйл ажиллагаа ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (11,'J','Мэдээлэл, холбоо',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (12,'K','Санхүүгийн болон даатгалын үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (13,'L','Үл хөдлөх хөрөнгийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (14,'N','Захиргааны болон дэмжлэг үзүүлэх үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (15,'P','Боловсрол',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (16,'Q','Хүний эрүүл мэнд ба нийгмийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (17,'O','Төрийн удирдлага ба батлан хамгаалах үйл ажиллагаа, албан журмын нийгмийн хамгаалал',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (18,'M','Мэргэжлийн, шинжлэх ухаан болон техникийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (19,'R','Урлаг, үзвэр, тоглоом наадам',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (20,'S','Үйлчилгээний бусад үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (21,'T','Хүн хөлслөн ажиллуулдаг өрхийн ажиллагаа; өрхийн өөрийн хэрэглээнд зориулан үйлдвэрлэсэн, хэмжээг нь тодорхойлох боломжгүй бүтээгдэхүүн, үйлчилгээ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (22,'U','Олон улсын байгууллага, суурин төлөөлөгчийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (23,'A02','Ойн аж ахуй, мод бэлтгэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (24,'A03','Загас агнуур, үржүүлэг',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (25,'B05','Чулуун нүүрс, хүрэн нүүрс олборлолт',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (26,'B06','Түүхий газрын тос, байгалийн хийн олборлолт',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (27,'B07','Металлын хүдэр олборлолт ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (28,'B08','Бусад ашигт малтмал олборлолт',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (29,'B09','Уул уурхай, олборлолтын туслах үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (30,'C10','Хүнсний бүтээгдэхүүний үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (31,'C11','Ундаа үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (32,'C12','Тамхи үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (33,'C13','Нэхмэлийн үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (34,'C14','Хувцас үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (35,'C15','Арьс, арьсан бүтээгдэхүүн үйлдвэрлэл ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (36,'C16','Тавилгаас бусад мод болон модон бүтээгдэхүүний үйдвэрлэл; сүрэл, дэрсэн эдлэл үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (37,'C17','Цаас болон цаасан бүтээгдэхүүний үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (38,'C18','Хэвлэх, дуу бичлэгийн хувилах, дахин үйлдвэрлэх үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (39,'C19','Кокс болон боловсруулсан нефтийн бүтээгдэхүүний үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (40,'C20','Хими, химийн төрлийн бүтээгдэхүүний үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (41,'C21','Эм, эм бэлдмэл, химийн болон ургамлын гаралтай эмийн бүтээгдэхүүний үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (42,'C22','Резинэн болон хуванцар бүтээгдэхүүний үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (43,'C23','Төмөрлөг бус эрдэс бодисоор хийсэн эдлэл үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (44,'C24','Металл үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (45,'C25','Машин, тоног төхөөрөмжөөс бусад металл бүтээгдэхүүний үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (46,'C26','Компьютер, электроник болон хараа зүйн бүтээгдэхүүний үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (47,'C27','Цахилгаан тоног төхөөрөмжийн үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (48,'C28','Дээрх дэд салбарт ороогүй бусад машин, тоног төхөөрөмжийн үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (49,'C29','Моторт авто тээврийн хэрэгсэл, чиргүүл, хагас чиргүүл үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (50,'C30','Тээврийн хэрэгслийн бусад тоног төхөөрөмж үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (51,'C31','Тавилга үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (52,'C32','Бусад боловсруулах үйлдвэрлэл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (53,'C33','Машин, тоног төхөөрөмжийн угсралт, суурилуулалт ба засвар',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (54,'D34','Цахилгаан, хий, уур агааржуулалтын хангамж',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (55,'E36','Ус хуримтлуулах, ариутгах, усан хангамжийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (56,'E37','Бохир ус хуримтлуулах, цэвэрлэх, ариутгах үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (57,'E38','Хог хаягдал цуглуулах, ариутгах, боловсруулах үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (58,'E39','Хог, хаягдлын менежментийн бусад үйл ажиллагаа ба цэвэрлэх үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (59,'F41','Барилга угсралт',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (60,'F42','Иргэний зориулалттай инженерийн байгууламжийн угсралтын үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (61,'F43','Барилгын тусгай үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (62,'G45','Моторт тээврийн хэрэгсэл, мотоциклийн бөөний болон жижиглэн худалдаа, засвар үйлчилгээ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (63,'G46','Машин, мотоциклээс бусад барааны бөөний худалдаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (64,'G47','Машин, мотоциклээс бусад барааны жижиглэн худалдаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (65,'H49','Газрын тээвэр болон хийн хоолойн тээвэр',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (66,'H50','Усан замын тээвэр',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (67,'H51','Агаарын тээвэр',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (68,'H52','Агуулахын болон тээврийн туслах үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (69,'H53','Шуудан, зарлага, элчийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (70,'I55','Байр, сууцаар хангах үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (71,'I56','Хоол ундаар үйлчлэх үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (72,'J58','Эх бэлтгэх, нийтлэх үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (73,'J59','Кино, видео, телевизийн хөтөлбөрийн үйлдвэрлэл, бичлэг хийх болон хөгжим, ая үйлдвэрлэх үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (74,'J60','Өргөн нэвтрүүлэг бэлтгэх, дамжуулах үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (75,'J61','Цахилгаан холбоо',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (76,'J62','Компьютер програмчлал, зөвлөгөө болон түүнд холбогдох үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (77,'J63','Мэдээллээр үйлчлэх үйл ажиллагаа ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (78,'K64','Даатгал, тэтгэврийн сангийн үйл ажиллагаанаас бусад санхүүгийн үйлчилгээ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (79,'K65','Албан журмын нийгмийн даатгалаас бусад даатгал, давхар даатгал, тэтгэврийн сангийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (80,'K66','Санхүүгийн бусад үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (81,'L68','Үл хөдлөх хөрөнгийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (82,'N77','Түрээсийн болон лизингийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (83,'N78','Ажил эрхлэлтийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (84,'N79','Аялал, жуулчлалын агентлаг, аяллын оператор болон захиалгат бусад үйлчилгээний үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (85,'N80','Аюулгүйн хамгаалал, мөрдөх үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (86,'N81','Байшин барилга, газрын гадаргуун төрх байдлын талаарх үйлчилгээний үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (87,'N82','Албан байгууллагын захиргааны ажил, албан газрын бусад туслах болон бизнесийн бусад туслах үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (88,'P85','Боловсрол',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (89,'Q86','Хүний эрүүл мэндийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (90,'Q87','Оршин суугчдад үзүүлэх халамжийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (91,'Q88','Зориулалтын байргүй нийгмийн тусламжийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (92,'O84','Төрийн удирдлага ба батлан хамгаалах үйл ажиллагаа, албан журмын нийгмийн хамгаалал',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (93,'M69','Хуулийн болон бүртгэлийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (94,'M70','Харъяалах дээд/толгой байгууллагын үйл ажиллагаа; менежментийн зөвлөгөө өгөх үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (95,'M71','Архитектур болон инженерийн үйл ажиллагаа; техникийн туршилт, шинжилгээ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (96,'M72','Шинжлэх ухааны эрдэм шинжилгээ, ололт, судалгааны үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (97,'M73','Сурталчилгааны ажил, зах зээлийн судалгаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (98,'M74','Мэргэжлийн, шинжлэх ухаан, техникийн ажлын бусад үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (99,'M75','Мал эмнэлгийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (100,'R90','Бүтээл туурвих, урлаг, үзвэр үйлчилгээний үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (101,'R91','Номын сан, архив, музей болон бусад соёлын үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (102,'R92','Мөрийтэй тоглоомын газрын үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (103,'R93','Спорт, зугаа цэнгэл, чөлөөт цагийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (104,'S94','Гишүүнчлэл бүхий байгууллагын үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (105,'S95','Хувийн болон өрхийн хэрэглээний бараа, компьютерын засвар, үйлчилгээ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (106,'S96','Хувийн үйлчилгээний бусад үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (107,'T97','Хүн хөлслөн ажиллуулдаг өрхийн ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (108,'T98','Өрхийн өөрийн хэрэглээнд зориулан үйлдвэрлэсэн, хэмжээг нь тодорхойлох боломжгүй бүтээгдэхүүн, үйлчилгээ',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_DEDICATION (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (109,'U99','Олон улсын байгууллага, суурин төлөөлөгчийн үйл ажиллагаа',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
REM INSERTING into LIMS.CREDIT_PAYMENT_TYPE
SET DEFINE OFF;
Insert into LIMS.CREDIT_PAYMENT_TYPE (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (1,'01','Жилээр',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_PAYMENT_TYPE (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (2,'02','Хагас жилээр',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_PAYMENT_TYPE (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (3,'03','Улиралаар',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_PAYMENT_TYPE (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (4,'04','Сараар',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_PAYMENT_TYPE (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (5,'05','Хувь тэнцүүлсэн',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CREDIT_PAYMENT_TYPE (ID,CODE,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (6,'06','Тэгш бус',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1);
REM INSERTING into LIMS.CREDIT_QUALITY_MAP
SET DEFINE OFF;
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (2,9,1,1,to_date('10-FEB-15','DD-MON-RR'),1,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (64,103,2,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (65,104,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (66,105,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (68,107,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (69,108,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (70,109,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (71,110,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (72,111,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (73,112,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (74,113,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (75,114,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (76,115,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (77,116,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (78,117,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (80,119,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (81,120,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (101,121,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (102,122,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (103,128,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (105,130,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (106,131,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (107,132,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (108,133,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (109,134,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (117,151,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (123,163,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (67,106,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (104,129,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (41,81,1,1,to_date('12-FEB-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (116,150,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (122,156,1,1,to_date('16-MAR-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (4,42,2,1,to_date('10-FEB-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (5,43,5,1,to_date('10-FEB-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (6,44,2,1,to_date('11-FEB-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (21,62,2,1,to_date('11-FEB-15','DD-MON-RR'),2,null,null);
Insert into LIMS.CREDIT_QUALITY_MAP (ID,CREDIT_ID,QUALITY_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,UPDATED_DATE,UPDATED_USER_ID) values (79,118,1,1,to_date('15-MAR-15','DD-MON-RR'),2,null,null);
REM INSERTING into LIMS.CREDIT_SCHEDULE
SET DEFINE OFF;
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (21,121,null,222,to_date('20-MAR-15','DD-MON-RR'),40,123,12,135,135,to_date('20-APR-15','DD-MON-RR'),1,1,to_date('15-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (22,122,null,222,to_date('20-MAR-15','DD-MON-RR'),40,123,12,135,135,to_date('20-APR-15','DD-MON-RR'),1,1,to_date('15-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (26,134,null,233,to_date('03-MAR-15','DD-MON-RR'),1,1,2,3,4,to_date('03-MAR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (24,133,null,121,to_date('03-MAR-15','DD-MON-RR'),1,23,123,123,1,to_date('03-MAR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (25,133,null,121,to_date('03-APR-15','DD-MON-RR'),30,123,123,123,12,to_date('03-APR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (27,134,null,233,to_date('03-APR-15','DD-MON-RR'),30,5,6,7,8,to_date('03-APR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (48,151,null,2,to_date('19-MAR-15','DD-MON-RR'),15,21,312,312,324,to_date('19-MAR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (60,163,null,234234,to_date('27-MAR-15','DD-MON-RR'),23,345,53453,45,5421,to_date('27-MAR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (61,163,null,234234,to_date('27-APR-15','DD-MON-RR'),30,56,789879,5,4365,to_date('27-APR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (62,163,null,234234,to_date('27-MAY-15','DD-MON-RR'),31,7,534,87,13222,to_date('27-MAY-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (63,163,null,234234,to_date('27-JUN-15','DD-MON-RR'),30,456,5243,789,2,to_date('27-JUN-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (46,150,null,2,to_date('19-MAR-15','DD-MON-RR'),15,21,312,312,324,to_date('19-MAR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (58,156,null,2,to_date('19-MAR-15','DD-MON-RR'),15,21,312,312,324,to_date('19-MAR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
Insert into LIMS.CREDIT_SCHEDULE (ID,CREDIT_ID,SCHEDULE_TYPE_ID,ONE_AMOUNT,TARGET_DATE,DAYS,MAIN_AMOUNT,INTEREST_AMOUNT,TOTAL_AMOUNT,BALANCE,DEADLINE,STATUS_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (59,156,null,2,to_date('19-APR-15','DD-MON-RR'),30,321,12,3312,123,to_date('19-APR-15','DD-MON-RR'),1,1,to_date('16-MAR-15','DD-MON-RR'),2);
REM INSERTING into LIMS.CREDIT_TYPE
SET DEFINE OFF;
Insert into LIMS.CREDIT_TYPE (ID,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CODE) values (1,'Энгийн зээл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1,null);
Insert into LIMS.CREDIT_TYPE (ID,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CODE) values (2,'Цалингийн зээл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1,null);
Insert into LIMS.CREDIT_TYPE (ID,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CODE) values (3,'Тэтгэвэр барьцаалсан зээл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1,null);
Insert into LIMS.CREDIT_TYPE (ID,NAME,DESCRIPTION,PARENT_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CODE) values (4,'Бизнесийн зээл',null,null,1,to_date('07-FEB-15','DD-MON-RR'),1,null);
REM INSERTING into LIMS.CURRENCY
SET DEFINE OFF;
Insert into LIMS.CURRENCY (ID,NAME,ABBREVIATION,SYMBOL,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (1,'Монгол төгрөг','Tugrug','MNT',1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CURRENCY (ID,NAME,ABBREVIATION,SYMBOL,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (2,'Америк доллар','Dollar','USD',1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CURRENCY (ID,NAME,ABBREVIATION,SYMBOL,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (3,'Орос рубель','Ruble','RUB',1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CURRENCY (ID,NAME,ABBREVIATION,SYMBOL,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (4,'Хятад юань','Yuan','CNY',1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CURRENCY (ID,NAME,ABBREVIATION,SYMBOL,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (5,'Япон ень','Yen','JPY',1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CURRENCY (ID,NAME,ABBREVIATION,SYMBOL,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (6,'Их британи паунд','Pound','GBP',1,to_date('07-FEB-15','DD-MON-RR'),1);
Insert into LIMS.CURRENCY (ID,NAME,ABBREVIATION,SYMBOL,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (7,'Евро','Euro','EUR',1,to_date('07-FEB-15','DD-MON-RR'),1);
REM INSERTING into LIMS.CUSTOMER
SET DEFINE OFF;
Insert into LIMS.CUSTOMER (ID,NAME) values (1,'Lims');
Insert into LIMS.CUSTOMER (ID,NAME) values (2,'Standart capital');
Insert into LIMS.CUSTOMER (ID,NAME) values (3,'Credit Mongol');
REM INSERTING into LIMS.DEBIT_TYPE
SET DEFINE OFF;
REM INSERTING into LIMS.DEBTOR
SET DEFINE OFF;
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (6,1,to_date('05-FEB-15','DD-MON-RR'),1,11,null,'uiouioui','iyuuio','yuiyu');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (21,1,to_date('06-FEB-15','DD-MON-RR'),1,21,null,'dsfsd23423','sdfsdf','dfsdf');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (121,1,to_date('05-MAR-15','DD-MON-RR'),2,null,null,'4512759','Компанийн нэр',null);
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (101,1,to_date('17-FEB-15','DD-MON-RR'),2,101,null,'33DFGDFG','SFSDF','ASDA');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (103,1,to_date('17-FEB-15','DD-MON-RR'),2,102,null,'ӨЮ86010777','Мөнх-эрдэнэ','Бүрэнжаргал');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (107,1,to_date('17-FEB-15','DD-MON-RR'),2,104,null,'ӨЮ86010756','Мөнх-эрдэнэ','Бүрэнжаргал');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (22,1,to_date('06-FEB-15','DD-MON-RR'),1,30,null,'ttee335566','eeeee44666','eeeee44');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (23,1,to_date('06-FEB-15','DD-MON-RR'),1,32,null,'ggr44rr55r','ggrrrrr','ggrrrrr');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (81,1,to_date('12-FEB-15','DD-MON-RR'),2,81,null,'МЮ86010777','Мөнх-эрдэнэ','Бүрэнцжаргал');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (5,1,to_date('05-FEB-15','DD-MON-RR'),1,10,null,'ggthth','hth','fghhtht');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (7,1,to_date('05-FEB-15','DD-MON-RR'),1,12,null,'ggr4234234','asdasd','asda');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (41,1,to_date('10-FEB-15','DD-MON-RR'),1,41,null,'HFGHFGH','HFGHFGH','HFGH');
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (61,1,to_date('11-FEB-15','DD-MON-RR'),2,null,12,'WERWER','EWRWER',null);
Insert into LIMS.DEBTOR (ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID,CITIZEN_ID,LEGAL_ENTITY_ID,REGISTER_NUMBER,NAME,LAST_NAME) values (105,1,to_date('17-FEB-15','DD-MON-RR'),2,103,null,'ӨЮ86010766','Мөнх-эрдэнэ','Бүрэнжаргал');
REM INSERTING into LIMS.JOB
SET DEFINE OFF;
REM INSERTING into LIMS.LEGAL_ENTITY
SET DEFINE OFF;
Insert into LIMS.LEGAL_ENTITY (ID,NAME,NAME_EN,REGISTER_NUMBER,TAX_NUMBER,TYPE_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (21,'Компанийн нэр','Company name','4512759','4512759',2,1,to_date('05-MAR-15','DD-MON-RR'),2);
Insert into LIMS.LEGAL_ENTITY (ID,NAME,NAME_EN,REGISTER_NUMBER,TAX_NUMBER,TYPE_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (10,'ZDFSFDSF','DSFSDF','SDFSDF','SDFSDF',3,1,to_date('11-FEB-15','DD-MON-RR'),2);
Insert into LIMS.LEGAL_ENTITY (ID,NAME,NAME_EN,REGISTER_NUMBER,TAX_NUMBER,TYPE_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (12,'EWRWER','WERWE','WERWER','WERWER',3,1,to_date('11-FEB-15','DD-MON-RR'),2);
REM INSERTING into LIMS.LEGAL_ENTITY_ACTIVITY
SET DEFINE OFF;
REM INSERTING into LIMS.LEGAL_ENTITY_OWNER_MAP
SET DEFINE OFF;
Insert into LIMS.LEGAL_ENTITY_OWNER_MAP (ID,LEGAL_ENTITY_ID,CITIZEN_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (21,21,121,1,to_date('05-MAR-15','DD-MON-RR'),2);
Insert into LIMS.LEGAL_ENTITY_OWNER_MAP (ID,LEGAL_ENTITY_ID,CITIZEN_ID,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (1,10,61,1,to_date('11-FEB-15','DD-MON-RR'),2);
REM INSERTING into LIMS.LEGAL_ENTITY_TYPE
SET DEFINE OFF;
Insert into LIMS.LEGAL_ENTITY_TYPE (ID,NAME,CODE,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (1,'ХК','01',1,null,null);
Insert into LIMS.LEGAL_ENTITY_TYPE (ID,NAME,CODE,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (2,'ХХК','02',1,null,null);
Insert into LIMS.LEGAL_ENTITY_TYPE (ID,NAME,CODE,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (3,'ХЗХ','03',1,null,null);
Insert into LIMS.LEGAL_ENTITY_TYPE (ID,NAME,CODE,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (4,'Хоршоо','04',1,null,null);
Insert into LIMS.LEGAL_ENTITY_TYPE (ID,NAME,CODE,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (5,'ТББ','05',1,null,null);
Insert into LIMS.LEGAL_ENTITY_TYPE (ID,NAME,CODE,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (6,'ОНБ','06',1,null,null);
Insert into LIMS.LEGAL_ENTITY_TYPE (ID,NAME,CODE,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (7,'Сан','07',1,null,null);
Insert into LIMS.LEGAL_ENTITY_TYPE (ID,NAME,CODE,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (8,'Бусад','08',1,null,null);
REM INSERTING into LIMS.QUALITY
SET DEFINE OFF;
Insert into LIMS.QUALITY (ID,NAME) values (1,'A');
Insert into LIMS.QUALITY (ID,NAME) values (2,'B');
Insert into LIMS.QUALITY (ID,NAME) values (3,'C');
Insert into LIMS.QUALITY (ID,NAME) values (4,'D');
Insert into LIMS.QUALITY (ID,NAME) values (5,'F');
REM INSERTING into LIMS.SCHEDULE_TYPE
SET DEFINE OFF;
REM INSERTING into LIMS.SUM_KHOROO
SET DEFINE OFF;
REM INSERTING into LIMS.USERS
SET DEFINE OFF;
Insert into LIMS.USERS (ID,CUSTOMER_ID,USERNAME,EMAIL,PASSWORD,PASSWORD_TOKEN,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (2,1,'user1','user1@lims.mn','fe789b9b2a5d430a4cd16e990ff2e886bb766ca8','a',1,to_date('09-FEB-15','DD-MON-RR'),1);
Insert into LIMS.USERS (ID,CUSTOMER_ID,USERNAME,EMAIL,PASSWORD,PASSWORD_TOKEN,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (3,2,'user2','user2@lims.mn','60134d45eb64ed3b5685e18832bc1004972c6a0c','b',1,to_date('09-FEB-15','DD-MON-RR'),1);
Insert into LIMS.USERS (ID,CUSTOMER_ID,USERNAME,EMAIL,PASSWORD,PASSWORD_TOKEN,IS_ACTIVE,CREATED_DATE,CREATED_USER_ID) values (4,3,'user3','user3@lims.mn','33f5e65a506f9f904f8bfd3842ea577135e45d60','c',1,to_date('09-FEB-15','DD-MON-RR'),1);
REM INSERTING into LIMS.USERS_DETAIL
SET DEFINE OFF;
--------------------------------------------------------
--  DDL for Index CREDIT_SCHEDULE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CREDIT_SCHEDULE_PK" ON "LIMS"."CREDIT_SCHEDULE" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index SCHEDULE_TYPE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."SCHEDULE_TYPE_PK" ON "LIMS"."SCHEDULE_TYPE" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index LEGAL_ENTITY_ACTIVITY_PK1
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."LEGAL_ENTITY_ACTIVITY_PK1" ON "LIMS"."LEGAL_ENTITY_ACTIVITY" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index LEGAL_ENTITY_ACTIVITY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."LEGAL_ENTITY_ACTIVITY_PK" ON "LIMS"."ACTIVITY" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index LEGAL_ENTITY_OWNER_MAP_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."LEGAL_ENTITY_OWNER_MAP_PK" ON "LIMS"."LEGAL_ENTITY_OWNER_MAP" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index LEGAL_ENTITY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."LEGAL_ENTITY_PK" ON "LIMS"."LEGAL_ENTITY" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index LEGAL_ENTITY_UK1
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."LEGAL_ENTITY_UK1" ON "LIMS"."LEGAL_ENTITY" ("REGISTER_NUMBER") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index SUM_KHOROO_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."SUM_KHOROO_PK" ON "LIMS"."SUM_KHOROO" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index LEGAL_ENTITY_TYPE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."LEGAL_ENTITY_TYPE_PK" ON "LIMS"."LEGAL_ENTITY_TYPE" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index AIMAG_DUUREG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."AIMAG_DUUREG_PK" ON "LIMS"."AIMAG_DUUREG" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CUSTOMER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CUSTOMER_PK" ON "LIMS"."CUSTOMER" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index USERS_DETAIL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."USERS_DETAIL_PK" ON "LIMS"."USERS_DETAIL" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index USERS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."USERS_PK" ON "LIMS"."USERS" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index DEBIT_TYPE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."DEBIT_TYPE_PK" ON "LIMS"."DEBIT_TYPE" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CREDIT_QUALITY_MAP_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CREDIT_QUALITY_MAP_PK" ON "LIMS"."CREDIT_QUALITY_MAP" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index QUALITY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."QUALITY_PK" ON "LIMS"."QUALITY" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index TABLE1_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."TABLE1_PK" ON "LIMS"."CREDIT_CONTRACT_MAP" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CONTRACT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CONTRACT_PK" ON "LIMS"."CONTRACT" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CREDIT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CREDIT_PK" ON "LIMS"."CREDIT" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CREDIT_PAYMENT_TYPE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CREDIT_PAYMENT_TYPE_PK" ON "LIMS"."CREDIT_PAYMENT_TYPE" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CREDIT_DEDICATION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CREDIT_DEDICATION_PK" ON "LIMS"."CREDIT_DEDICATION" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CURRENCY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CURRENCY_PK" ON "LIMS"."CURRENCY" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CREDIT_TYPE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CREDIT_TYPE_PK" ON "LIMS"."CREDIT_TYPE" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CITIZEN_ADDRESS_MAP_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CITIZEN_ADDRESS_MAP_PK" ON "LIMS"."CITIZEN_ADDRESS_MAP" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index JOB_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."JOB_PK" ON "LIMS"."JOB" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index DEBTOR_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."DEBTOR_PK" ON "LIMS"."DEBTOR" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index DEBTOR_UK1
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."DEBTOR_UK1" ON "LIMS"."DEBTOR" ("REGISTER_NUMBER") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CITIZEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CITIZEN_PK" ON "LIMS"."CITIZEN" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index CITIZEN_UK1
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."CITIZEN_UK1" ON "LIMS"."CITIZEN" ("REGISTER_NUMBER") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  DDL for Index ADDRESS_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "LIMS"."ADDRESS_PK" ON "LIMS"."ADDRESS" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS" ;
--------------------------------------------------------
--  Constraints for Table CREDIT_DEDICATION
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_DEDICATION" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_DEDICATION" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_DEDICATION" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_DEDICATION" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_DEDICATION" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_DEDICATION" ADD CONSTRAINT "CREDIT_DEDICATION_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table CREDIT
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("INITIAL_AMOUNT" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("TOTAL_AMOUNT" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("TOTAL_BALANCE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("CURRENCY_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("STATUS_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" ADD CONSTRAINT "CREDIT_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("CUSTOMER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT" MODIFY ("DEBTOR_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table CURRENCY
--------------------------------------------------------

  ALTER TABLE "LIMS"."CURRENCY" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CURRENCY" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CURRENCY" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CURRENCY" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CURRENCY" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CURRENCY" ADD CONSTRAINT "CURRENCY_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table LEGAL_ENTITY
--------------------------------------------------------

  ALTER TABLE "LIMS"."LEGAL_ENTITY" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY" MODIFY ("REGISTER_NUMBER" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY" MODIFY ("TYPE_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY" ADD CONSTRAINT "LEGAL_ENTITY_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
  ALTER TABLE "LIMS"."LEGAL_ENTITY" ADD CONSTRAINT "LEGAL_ENTITY_UK1" UNIQUE ("REGISTER_NUMBER")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table SCHEDULE_TYPE
--------------------------------------------------------

  ALTER TABLE "LIMS"."SCHEDULE_TYPE" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SCHEDULE_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SCHEDULE_TYPE" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SCHEDULE_TYPE" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SCHEDULE_TYPE" ADD CONSTRAINT "SCHEDULE_TYPE_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table DEBTOR
--------------------------------------------------------

  ALTER TABLE "LIMS"."DEBTOR" ADD CONSTRAINT "DEBTOR_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
  ALTER TABLE "LIMS"."DEBTOR" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBTOR" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBTOR" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBTOR" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBTOR" MODIFY ("REGISTER_NUMBER" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBTOR" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBTOR" ADD CONSTRAINT "DEBTOR_UK1" UNIQUE ("REGISTER_NUMBER")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table CONTRACT
--------------------------------------------------------

  ALTER TABLE "LIMS"."CONTRACT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CONTRACT" MODIFY ("CONTRACT_TYPE_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CONTRACT" MODIFY ("TARGET_REGISTER_NUMBER" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CONTRACT" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CONTRACT" ADD CONSTRAINT "CONTRACT_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table CREDIT_TYPE
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_TYPE" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_TYPE" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_TYPE" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_TYPE" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_TYPE" ADD CONSTRAINT "CREDIT_TYPE_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table QUALITY
--------------------------------------------------------

  ALTER TABLE "LIMS"."QUALITY" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."QUALITY" ADD CONSTRAINT "QUALITY_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
  ALTER TABLE "LIMS"."QUALITY" MODIFY ("NAME" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SUM_KHOROO
--------------------------------------------------------

  ALTER TABLE "LIMS"."SUM_KHOROO" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SUM_KHOROO" MODIFY ("AIMAG_NIISLEL_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SUM_KHOROO" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SUM_KHOROO" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SUM_KHOROO" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SUM_KHOROO" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."SUM_KHOROO" ADD CONSTRAINT "SUM_KHOROO_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table CREDIT_PAYMENT_TYPE
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_PAYMENT_TYPE" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_PAYMENT_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_PAYMENT_TYPE" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_PAYMENT_TYPE" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_PAYMENT_TYPE" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_PAYMENT_TYPE" ADD CONSTRAINT "CREDIT_PAYMENT_TYPE_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table DEBIT_TYPE
--------------------------------------------------------

  ALTER TABLE "LIMS"."DEBIT_TYPE" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBIT_TYPE" MODIFY ("CODE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBIT_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBIT_TYPE" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBIT_TYPE" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBIT_TYPE" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."DEBIT_TYPE" ADD CONSTRAINT "DEBIT_TYPE_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table LEGAL_ENTITY_OWNER_MAP
--------------------------------------------------------

  ALTER TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" MODIFY ("LEGAL_ENTITY_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" MODIFY ("CITIZEN_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" ADD CONSTRAINT "LEGAL_ENTITY_OWNER_MAP_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table AIMAG_DUUREG
--------------------------------------------------------

  ALTER TABLE "LIMS"."AIMAG_DUUREG" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."AIMAG_DUUREG" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."AIMAG_DUUREG" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."AIMAG_DUUREG" ADD CONSTRAINT "AIMAG_DUUREG_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table CREDIT_SCHEDULE
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_SCHEDULE" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_SCHEDULE" ADD CONSTRAINT "CREDIT_SCHEDULE_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table USERS_DETAIL
--------------------------------------------------------

  ALTER TABLE "LIMS"."USERS_DETAIL" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."USERS_DETAIL" MODIFY ("USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."USERS_DETAIL" MODIFY ("CUSTOMER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."USERS_DETAIL" MODIFY ("FIRST_NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."USERS_DETAIL" ADD CONSTRAINT "USERS_DETAIL_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table CITIZEN
--------------------------------------------------------

  ALTER TABLE "LIMS"."CITIZEN" ADD CONSTRAINT "CITIZEN_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
  ALTER TABLE "LIMS"."CITIZEN" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CITIZEN" ADD CONSTRAINT "CITIZEN_UK1" UNIQUE ("REGISTER_NUMBER")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table CUSTOMER
--------------------------------------------------------

  ALTER TABLE "LIMS"."CUSTOMER" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CUSTOMER" ADD CONSTRAINT "CUSTOMER_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table ACTIVITY
--------------------------------------------------------

  ALTER TABLE "LIMS"."ACTIVITY" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."ACTIVITY" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."ACTIVITY" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."ACTIVITY" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."ACTIVITY" ADD CONSTRAINT "LEGAL_ENTITY_ACTIVITY_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table USERS
--------------------------------------------------------

  ALTER TABLE "LIMS"."USERS" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."USERS" MODIFY ("CUSTOMER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."USERS" MODIFY ("PASSWORD" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."USERS" ADD CONSTRAINT "USERS_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table CREDIT_CONTRACT_MAP
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_CONTRACT_MAP" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_CONTRACT_MAP" MODIFY ("CREDIT_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_CONTRACT_MAP" MODIFY ("CONTRACT_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_CONTRACT_MAP" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_CONTRACT_MAP" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_CONTRACT_MAP" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_CONTRACT_MAP" ADD CONSTRAINT "TABLE1_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table LEGAL_ENTITY_TYPE
--------------------------------------------------------

  ALTER TABLE "LIMS"."LEGAL_ENTITY_TYPE" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_TYPE" ADD CONSTRAINT "LEGAL_ENTITY_TYPE_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
  ALTER TABLE "LIMS"."LEGAL_ENTITY_TYPE" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table CREDIT_QUALITY_MAP
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_QUALITY_MAP" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_QUALITY_MAP" MODIFY ("CREDIT_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_QUALITY_MAP" MODIFY ("QUALITY_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_QUALITY_MAP" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_QUALITY_MAP" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_QUALITY_MAP" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CREDIT_QUALITY_MAP" ADD CONSTRAINT "CREDIT_QUALITY_MAP_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table CITIZEN_ADDRESS_MAP
--------------------------------------------------------

  ALTER TABLE "LIMS"."CITIZEN_ADDRESS_MAP" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."CITIZEN_ADDRESS_MAP" ADD CONSTRAINT "CITIZEN_ADDRESS_MAP_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table ADDRESS
--------------------------------------------------------

  ALTER TABLE "LIMS"."ADDRESS" ADD CONSTRAINT "ADDRESS_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS"  ENABLE;
  ALTER TABLE "LIMS"."ADDRESS" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."ADDRESS" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."ADDRESS" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."ADDRESS" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table LEGAL_ENTITY_ACTIVITY
--------------------------------------------------------

  ALTER TABLE "LIMS"."LEGAL_ENTITY_ACTIVITY" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_ACTIVITY" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_ACTIVITY" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_ACTIVITY" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."LEGAL_ENTITY_ACTIVITY" ADD CONSTRAINT "LEGAL_ENTITY_ACTIVITY_PK1" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table JOB
--------------------------------------------------------

  ALTER TABLE "LIMS"."JOB" ADD CONSTRAINT "JOB_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "LIMS"  ENABLE;
  ALTER TABLE "LIMS"."JOB" MODIFY ("CREATED_USER_ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."JOB" MODIFY ("CREATED_DATE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."JOB" MODIFY ("IS_ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."JOB" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."JOB" MODIFY ("POSITION_NAME" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."JOB" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."JOB" MODIFY ("IS_CURRENT" NOT NULL ENABLE);
  ALTER TABLE "LIMS"."JOB" MODIFY ("CITIZEN_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Ref Constraints for Table CREDIT
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT" ADD CONSTRAINT "CREDIT_CREDIT_DEDICATION_FK1" FOREIGN KEY ("DEDICATION_ID")
	  REFERENCES "LIMS"."CREDIT_DEDICATION" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT" ADD CONSTRAINT "CREDIT_CREDIT_PAYMENT_TYP_FK1" FOREIGN KEY ("PAYMENT_TYPE_ID")
	  REFERENCES "LIMS"."CREDIT_PAYMENT_TYPE" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT" ADD CONSTRAINT "CREDIT_CREDIT_PAYMENT_TYP_FK2" FOREIGN KEY ("INTEREST_PAYMENT_TYPE_ID")
	  REFERENCES "LIMS"."CREDIT_PAYMENT_TYPE" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT" ADD CONSTRAINT "CREDIT_CREDIT_TYPE_FK1" FOREIGN KEY ("TYPE_ID")
	  REFERENCES "LIMS"."CREDIT_TYPE" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT" ADD CONSTRAINT "CREDIT_CURRENCY_FK1" FOREIGN KEY ("CURRENCY_ID")
	  REFERENCES "LIMS"."CURRENCY" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT" ADD CONSTRAINT "CREDIT_CUSTOMER_FK1" FOREIGN KEY ("CUSTOMER_ID")
	  REFERENCES "LIMS"."CUSTOMER" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT" ADD CONSTRAINT "CREDIT_DEBTOR_FK1" FOREIGN KEY ("DEBTOR_ID")
	  REFERENCES "LIMS"."DEBTOR" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT" ADD CONSTRAINT "CREDIT_USERS_FK1" FOREIGN KEY ("CREATED_USER_ID")
	  REFERENCES "LIMS"."USERS" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table CREDIT_CONTRACT_MAP
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_CONTRACT_MAP" ADD CONSTRAINT "CREDIT_CONTRACT_MAP_CONTR_FK1" FOREIGN KEY ("CONTRACT_ID")
	  REFERENCES "LIMS"."CONTRACT" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT_CONTRACT_MAP" ADD CONSTRAINT "CREDIT_CONTRACT_MAP_CREDI_FK1" FOREIGN KEY ("CREDIT_ID")
	  REFERENCES "LIMS"."CREDIT" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table CREDIT_QUALITY_MAP
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_QUALITY_MAP" ADD CONSTRAINT "CREDIT_QUALITY_MAP_CREDIT_FK1" FOREIGN KEY ("CREDIT_ID")
	  REFERENCES "LIMS"."CREDIT" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT_QUALITY_MAP" ADD CONSTRAINT "CREDIT_QUALITY_MAP_QUALIT_FK1" FOREIGN KEY ("QUALITY_ID")
	  REFERENCES "LIMS"."QUALITY" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table CREDIT_SCHEDULE
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_SCHEDULE" ADD CONSTRAINT "CREDIT_SCHEDULE_CREDIT_FK1" FOREIGN KEY ("CREDIT_ID")
	  REFERENCES "LIMS"."CREDIT" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT_SCHEDULE" ADD CONSTRAINT "CREDIT_SCHEDULE_SCHEDULE__FK1" FOREIGN KEY ("SCHEDULE_TYPE_ID")
	  REFERENCES "LIMS"."SCHEDULE_TYPE" ("ID") ENABLE;
  ALTER TABLE "LIMS"."CREDIT_SCHEDULE" ADD CONSTRAINT "CREDIT_SCHEDULE_USERS_FK1" FOREIGN KEY ("CREATED_USER_ID")
	  REFERENCES "LIMS"."USERS" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table CREDIT_TYPE
--------------------------------------------------------

  ALTER TABLE "LIMS"."CREDIT_TYPE" ADD CONSTRAINT "CREDIT_TYPE_CREDIT_TYPE_FK1" FOREIGN KEY ("PARENT_ID")
	  REFERENCES "LIMS"."CREDIT_TYPE" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table DEBTOR
--------------------------------------------------------

  ALTER TABLE "LIMS"."DEBTOR" ADD CONSTRAINT "DEBTOR_CITIZEN_FK1" FOREIGN KEY ("CITIZEN_ID")
	  REFERENCES "LIMS"."CITIZEN" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table JOB
--------------------------------------------------------

  ALTER TABLE "LIMS"."JOB" ADD CONSTRAINT "JOB_CITIZEN_FK1" FOREIGN KEY ("CITIZEN_ID")
	  REFERENCES "LIMS"."CITIZEN" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table LEGAL_ENTITY
--------------------------------------------------------

  ALTER TABLE "LIMS"."LEGAL_ENTITY" ADD CONSTRAINT "LEGAL_ENTITY_LEGAL_ENTITY_FK1" FOREIGN KEY ("TYPE_ID")
	  REFERENCES "LIMS"."LEGAL_ENTITY_TYPE" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table LEGAL_ENTITY_ACTIVITY
--------------------------------------------------------

  ALTER TABLE "LIMS"."LEGAL_ENTITY_ACTIVITY" ADD CONSTRAINT "LEGAL_ENTITY_ACTIVITY_ACT_FK1" FOREIGN KEY ("ACTIVITY_ID")
	  REFERENCES "LIMS"."ACTIVITY" ("ID") ENABLE;
  ALTER TABLE "LIMS"."LEGAL_ENTITY_ACTIVITY" ADD CONSTRAINT "LEGAL_ENTITY_ACTIVITY_LEG_FK1" FOREIGN KEY ("LEGAL_ENTITY_ID")
	  REFERENCES "LIMS"."LEGAL_ENTITY" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table LEGAL_ENTITY_OWNER_MAP
--------------------------------------------------------

  ALTER TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" ADD CONSTRAINT "LEGAL_ENTITY_OWNER_MAP_CI_FK1" FOREIGN KEY ("CITIZEN_ID")
	  REFERENCES "LIMS"."CITIZEN" ("ID") ENABLE;
  ALTER TABLE "LIMS"."LEGAL_ENTITY_OWNER_MAP" ADD CONSTRAINT "LEGAL_ENTITY_OWNER_MAP_LE_FK1" FOREIGN KEY ("LEGAL_ENTITY_ID")
	  REFERENCES "LIMS"."LEGAL_ENTITY" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table SUM_KHOROO
--------------------------------------------------------

  ALTER TABLE "LIMS"."SUM_KHOROO" ADD CONSTRAINT "SUM_KHOROO_AIMAG_DUUREG_FK1" FOREIGN KEY ("AIMAG_NIISLEL_ID")
	  REFERENCES "LIMS"."AIMAG_DUUREG" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table USERS
--------------------------------------------------------

  ALTER TABLE "LIMS"."USERS" ADD CONSTRAINT "USERS_CUSTOMER_FK1" FOREIGN KEY ("CUSTOMER_ID")
	  REFERENCES "LIMS"."CUSTOMER" ("ID") ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table USERS_DETAIL
--------------------------------------------------------

  ALTER TABLE "LIMS"."USERS_DETAIL" ADD CONSTRAINT "USERS_DETAIL_CUSTOMER_FK1" FOREIGN KEY ("CUSTOMER_ID")
	  REFERENCES "LIMS"."CUSTOMER" ("ID") ENABLE;
  ALTER TABLE "LIMS"."USERS_DETAIL" ADD CONSTRAINT "USERS_DETAIL_USERS_FK1" FOREIGN KEY ("USER_ID")
	  REFERENCES "LIMS"."USERS" ("ID") ENABLE;
--------------------------------------------------------
--  DDL for Trigger ACTIVITY_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."ACTIVITY_TRG" BEFORE INSERT ON "ACTIVITY" 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT ACTIVITY_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."ACTIVITY_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger ADDRESS_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."ADDRESS_TRG" 
BEFORE INSERT ON ADDRESS 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.ID IS NULL THEN
      SELECT ADDRESS_ID_SEQ.NEXTVAL INTO :NEW.ID FROM SYS.DUAL;
    END IF;
  END;
END;
/
ALTER TRIGGER "LIMS"."ADDRESS_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger AIMAG_DUUREG_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."AIMAG_DUUREG_TRG" BEFORE INSERT ON AIMAG_DUUREG 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT AIMAG_DUUREG_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."AIMAG_DUUREG_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CITIZEN_ADDRESS_MAP_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CITIZEN_ADDRESS_MAP_TRG" BEFORE INSERT ON CITIZEN_ADDRESS_MAP 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CITIZEN_ADDRESS_MAP_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CITIZEN_ADDRESS_MAP_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CITIZEN_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CITIZEN_TRG" 
BEFORE INSERT ON CITIZEN 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.ID IS NULL THEN
      SELECT CITIZEN_ID_SEQ.NEXTVAL INTO :NEW.ID FROM SYS.DUAL;
    END IF;
  END;
END;
/
ALTER TRIGGER "LIMS"."CITIZEN_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CONTRACT_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CONTRACT_TRG" BEFORE INSERT ON CONTRACT 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CONTRACT_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CONTRACT_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CREDIT_CONTRACT_MAP_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CREDIT_CONTRACT_MAP_TRG" BEFORE INSERT ON CREDIT_CONTRACT_MAP 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CREDIT_CONTRACT_MAP_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CREDIT_CONTRACT_MAP_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CREDIT_DEDICATION_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CREDIT_DEDICATION_TRG" BEFORE INSERT ON CREDIT_DEDICATION 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CREDIT_DEDICATION_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
      END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CREDIT_DEDICATION_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CREDIT_PAYMENT_TYPE_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CREDIT_PAYMENT_TYPE_TRG" BEFORE INSERT ON CREDIT_PAYMENT_TYPE 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CREDIT_PAYMENT_TYPE_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CREDIT_PAYMENT_TYPE_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CREDIT_QUALITY_MAP_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CREDIT_QUALITY_MAP_TRG" BEFORE INSERT ON CREDIT_QUALITY_MAP 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CREDIT_QUALITY_MAP_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CREDIT_QUALITY_MAP_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CREDIT_SCHEDULE_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CREDIT_SCHEDULE_TRG" BEFORE INSERT ON CREDIT_SCHEDULE 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CREDIT_SCHEDULE_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CREDIT_SCHEDULE_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CREDIT_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CREDIT_TRG" BEFORE INSERT ON CREDIT 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CREDIT_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CREDIT_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CREDIT_TYPE_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CREDIT_TYPE_TRG" BEFORE INSERT ON CREDIT_TYPE 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CREDIT_TYPE_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CREDIT_TYPE_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CURRENCY_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CURRENCY_TRG" BEFORE INSERT ON CURRENCY 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CURRENCY_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CURRENCY_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger CUSTOMER_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."CUSTOMER_TRG" BEFORE INSERT ON CUSTOMER 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT CUSTOMER_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."CUSTOMER_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger DEBIT_TYPE_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."DEBIT_TYPE_TRG" BEFORE INSERT ON DEBIT_TYPE 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT DEBIT_TYPE_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."DEBIT_TYPE_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger DEBTOR_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."DEBTOR_TRG" 
BEFORE INSERT ON "DEBTOR" 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.ID IS NULL THEN
      SELECT DEBTOR_ID_SEQ.NEXTVAL INTO :NEW.ID FROM SYS.DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."DEBTOR_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger JOB_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."JOB_TRG" 
BEFORE INSERT ON JOB 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.ID IS NULL THEN
      SELECT JOB_ID_SEQ.NEXTVAL INTO :NEW.ID FROM SYS.DUAL;
      END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."JOB_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger LEGAL_ENTITY_ACTIVITY_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."LEGAL_ENTITY_ACTIVITY_TRG" BEFORE INSERT ON LEGAL_ENTITY_ACTIVITY 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT LEGAL_ENTITY_ACTIVITY_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."LEGAL_ENTITY_ACTIVITY_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger LEGAL_ENTITY_OWNER_MAP_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."LEGAL_ENTITY_OWNER_MAP_TRG" BEFORE INSERT ON LEGAL_ENTITY_OWNER_MAP 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT LEGAL_ENTITY_OWNER_MAP_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."LEGAL_ENTITY_OWNER_MAP_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger LEGAL_ENTITY_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."LEGAL_ENTITY_TRG" BEFORE INSERT ON LEGAL_ENTITY 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT LEGAL_ENTITY_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."LEGAL_ENTITY_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger LEGAL_ENTITY_TYPE_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."LEGAL_ENTITY_TYPE_TRG" BEFORE INSERT ON LEGAL_ENTITY_TYPE 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT LEGAL_ENTITY_TYPE_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."LEGAL_ENTITY_TYPE_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger LOGON_ALTER_TIME_TRIGGER
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."LOGON_ALTER_TIME_TRIGGER" 
AFTER LOGON ON DATABASE
BEGIN
  EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT = "YYYY-MM-DD HH24:MI:SS"'; 
END;
/
ALTER TRIGGER "LIMS"."LOGON_ALTER_TIME_TRIGGER" ENABLE;
--------------------------------------------------------
--  DDL for Trigger QUALITY_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."QUALITY_TRG" BEFORE INSERT ON QUALITY 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT QUALITY_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."QUALITY_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger SCHEDULE_TYPE_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."SCHEDULE_TYPE_TRG" 
BEFORE INSERT ON SCHEDULE_TYPE 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.ID IS NULL THEN
      SELECT SCHEDULE_TYPE_ID_SEQ.NEXTVAL INTO :NEW.ID FROM SYS.DUAL;
    END IF;
  END;
END;
/
ALTER TRIGGER "LIMS"."SCHEDULE_TYPE_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger SUM_KHOROO_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."SUM_KHOROO_TRG" BEFORE INSERT ON SUM_KHOROO 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT SUM_KHOROO_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."SUM_KHOROO_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger USERS_DETAIL_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."USERS_DETAIL_TRG" BEFORE INSERT ON USERS_DETAIL 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT USERS_DETAIL_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."USERS_DETAIL_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger USERS_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "LIMS"."USERS_TRG" BEFORE INSERT ON USERS 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF :NEW.ID IS NULL THEN
      SELECT USERS_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "LIMS"."USERS_TRG" ENABLE;
